Hệ thống quản lý trường học bằng PHP / MySQLi
1 <?php
2 error_reporting(0);
3 $conn=mysqli_connect('localhost','root','','sms2')or die(mysqli_error("Connection error"));
4 ?>
5 <?php
6 require_once('session1.php');
7 ?>
8 <?php
9 $id = $_GET['id'];
10 $select = "SELECT * FROM
11 staff WHERE staff_id='$id'";
12 $result = mysqli_fetch_array(mysqli_query($conn,$select));
13 $qry=mysqli_query($conn,$select);
14 if($qry)
15 {
16 foreach(mysqli_fetch_array($qry) as $k => $rec){
17 if(!is_numeric($k))
18 $$k = $rec;
19 }
20 }
21 ?>
22
23 <?php
24 SESSION_START();
25 ?>
26
27 <!DOCTYPE html>
28 <html>
29
30 <head>
31 <meta charset="utf-8">
32 <meta name="viewport" content="width=device-width, initial-scale=1.0">
33 <title>school management system</title>
34 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
35 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
36 <link href="assets/css/loader.css" rel="stylesheet" />
37 <script src="assets/js/canvasjs.min.js"></script>
38 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
39 <script src="assets/js/jquery-3.2.1.js"></script>
40 <!--codes to run the script for constituencies and counties-->
41 <script type='text/javascript'>
42 function OnSelectionChange(county_id) {
43 var selectedOption = county_id.options[county_id.selectedIndex];
44 document.getElementById('selectedcounty').value = selectedOption.value;
45 }
46 </script>
47 <script type="text/javascript">
48 function onclick(constituency_id){
49 <?php
50 $a=$_POST['county_id'];
51 echo $a;
52 ?>
53 }
54 </script>
55 <!--codes to run the script for constituencies and counties-->
56 <style type="text/css">
57 h4{
58 color:red;
59 }
60 </style>
61 <!--styling up the heading of form-->
62
63 </head>
64
65 <body >
66 <!--end of heading section-->
67 <ul class="nav navbar-right top-nav">
68 <div class="dropdown">
69 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
70 <?php
71 //Check to see if the user is logged in.if not redirect user to the loging page.
72
73 if(isset($_SESSION['fname']))
74 {
75 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
76 }else{
77 echo "<script type='text/javascript'>
78 alert( 'You must Log in to use the system');
79 </script>";
80 echo "<script>
81 window.location = 'index.php'
82 </script>";
83 }
84 ?>
85 <span class="caret"></span></button>
86 <ul class="dropdown-menu">
87 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
88 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
89 <li class="divider"></li>
90 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
91 </ul>
92 </div>
93 </ul>
94 <!--************************************************-->
95 <div style="
96 font-family:Nyala, Arial;
97 text-align: left;
98 background-color: #526F35;
99 padding: 20px;
100 color:white;
101 width: 100%;
102 height: 150px;">
103 <!--This codes to load the image loader-->
104 <div id="loading">
105 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
106 </div>
107 <!--this is the heading section-->
108 <h2>
109 <?php
110 $query=mysqli_query($conn,"select * from companyinfo");
111 $num_rows=mysqli_num_rows($query);
112 while($row=mysqli_fetch_array($query))
113 {
114 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
115 $cname = $row['cname'];
116 $cemail = $row['cemail'];
117 $ccontact = $row['ccontact'];
118 $clocation = $row['clocation'];
119 }?>
120 <?php
121 echo $cname;
122 ?>
123
124 <div style="float:right; font-size:20px;text-align:right;">
125
126 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
127 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
128 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
129
130 </div>
131 </h2>
132 </div>
133 <!--end of heading section-->
134
135 <div>
136 <ul class="nav nav-tabs">
137 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
138 <li ><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
139 <li class="active"><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
140 <li><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
141 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
142 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
143 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
144 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
145 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
146 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
147
148 </ul>
149 <div class="tab-content">
150 <div class="tab-pane active" role="tabpanel" id="tab-1">
151
152 <p>
153 <div class="table-responsive" >
154 <!--**************************************************************************************************************************-->
155 <div class="container" style="width:100%">
156
157 <ul class="nav nav-tabs">
158 <li ><a href="staff.php">New Staff Member <img src="assets/img/new.png"> </a></li>
159 <li><a href="viewstaff.php">View List<img src="assets/img/view2.png"></a></li>
160 <li class="active"><a href="edit_staff.php">Edit Staff <img src="assets/img/import.png"></a></li>
161 <li ><a href="staff_reports.php">Reports <img src="assets/img/import.png"></a></li>
162 </ul>
163 <br>
164
165 </div>
166 <!--**************ths is the success msg on saving the cord-->
167
168 <!--*************************************************************************************************************************-->
169
170 <div class="container-fluid">
171 <div class="row">
172 <div class="col-lg-6 col-lg-offset-3">
173 <div class="panel panel-primary">
174 <div class="panel-heading">Edit Staff Member</div>
175
176 <!-- /.panel-heading -->
177 <div class="panel-body">
178 <div class="table">
179
180 <form action="update_staff.php" method="POST" enctype="multipart/form-data">
181
182 <div style="float:left; position:relative">
183 <h4>Personal Details</h4>
184 <label>Staff NO:</label>
185 <input type="text" name="staff_id" readonly value="<?php echo $id?>" class="form-control">
186 <label>Sir name</label>
187 <input type="text" name="sirname" value="<?php echo $sirname?>" id="ssname" class="form-control" >
188
189 <label>Firstname</label>
190 <input type="text" name="firstname" value="<?php echo $firstname?>" id="sfname" class="form-control" >
191
192 <label>Last Name</label>
193 <input type="text" name="lastname" value="<?php echo $lastname?>" id="slname" class="form-control" >
194
195 <label>ID/Passport NO.</label>
196 <input type="text" name="idno" class="form-control" value="<?php echo $idno?>" >
197 <label>DOB</label>
198 <input type="date" name="dateofbirth" required class="form-control" max="2010-12-31" value="<?php echo $dateofbirth?>">
199 <label>Gender</label>
200 <select name="gender" class="form-control" class="form-control" value="<?php echo $dateofbirth?>">
201 <option value="male">Male</option>
202 <option value="female">Female</option>
203 </select>
204 <!-- <label>Country</label>
205 <select id="country_id" name="country_id" value="<?php echo $country_id?>" class="form-control">
206 <option></option>
207 <?php
208 $query=mysqli_query($conn,"select * from countries");
209 while($row=mysqli_fetch_array($query))
210 {
211 if($result['country_id'] == $row['country_id']){
212 $sel = "selected";
213 }else{
214 $sel = "";
215 }
216 ?>
217 <option value="<?php echo $row['country_id'];?>" <?=$sel?> > <?php echo $row['countryname'];?> </option>
218 <?php
219 } ?>
220 </select>
221
222 <label>County</label>
223 <select id="county_id" name="county_id" value="<?php echo $county_id?>" class="form-control">
224 <option></option>
225 <?php
226 $query=mysqli_query($conn,"select * from counties");
227 while($row=mysqli_fetch_array($query))
228 {
229 if($result['county_id'] == $row['county_id']){
230 $sel = "selected";
231 }else{
232 $sel = "";
233 }
234 ?>
235 <option value="<?php echo $row['county_id'];?>" <?=$sel?> > <?php echo $row['countyname'];?> </option>
236 <?php
237 } ?>
238 </select>
239
240 <label> Constituency</label>
241 <select id="constituency_id" name="constituency_id" value="<?php echo $constituency_id?>" class="form-control">
242 <option></option>
243 <?php
244 $query=mysqli_query($conn,"select * from constituency");
245 while($row=mysqli_fetch_array($query))
246 {
247 if($result['constituency_id'] == $row['constituency_id']){
248 $sel = "selected";
249 }else{
250 $sel = "";
251 }
252 ?>
253 <option value="<?php echo $row['constituency_id'];?>" <?=$sel?> > <?php echo $row['constituencyname'];?> </option>
254 <?php
255 } ?>
256 </select> -->
257
258 <label> Department</label>
259 <select id="department_id" name="department_id" value="<?php echo $department_id?>" class="form-control">
260 <option></option>
261 <?php
262 $query=mysqli_query($conn,"select * from departments");
263 while($row=mysqli_fetch_array($query))
264 {
265 if($result['department_id'] == $row['department_id']){
266 $sel = "selected";
267 }else{
268 $sel = "";
269 }
270 ?>
271 <option value="<?php echo $row['department_id'];?>" <?=$sel?> > <?php echo $row['departmentname'];?> </option>
272 <?php
273 } ?>
274 </select>
275
276 </div>
277 <!--section two-->
278 <div style="float:right; position:relative">
279 <h4>Contact Details</h4>
280
281 <label> Mobile</label>
282 <input type="number" name="mobile" required class="form-control" value="<?php echo $mobile?>">
283 <label> Email</label>
284 <input type="email" name="email" class="form-control" value="<?php echo $email?>">
285
286 <label> Address</label>
287 <input type="text" name="address" class="form-control" value="<?php echo $address?>">
288
289 <label> Zip Code</label>
290 <input type="text" name="zipcode" class="form-control" value="<?php echo $zipcode?>">
291
292 <label> Date of Appointment</label>
293 <input type="date" name="doa" required class="form-control" value="<?php echo $doa?>">
294
295 <label> KRA</label>
296 <input type="text" name="kra" class="form-control" value="<?php echo $kra?>">
297
298 <label> NSSF</label>
299 <input type="text" name="nssf" class="form-control" value="<?php echo $nssf?>">
300
301 <label> NHIF</label>
302 <input type="TEXT" name="nhif" required class="form-control" value="<?php echo $nhif?>" >
303
304 <label> Roles</label>
305 <input type="TEXT" name="roles" required class="form-control" value="<?php echo $roles?>" >
306
307 </textarea>
308 </div>
309 <!--this is section three-->
310 <div style="float:left; position:relative; clear:both;"><br>
311
312
313 <input type="submit" name="register" value="Save Record" class="btn btn-success"><br><br>
314 </div>
315 </form>
316 </div>
317 </div>
318 </div>
319 </div>
320 </div>
321
322 <!--*************************************PHP CODES TO SAVE THE DATA************************************************-->
323
324
325 <div class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
326 <p class="text-center text-danger" style="color:white;" >@J. Muthama Tel: +254729734768</p>
327 </div>
328 <script src="assets/js/jquery.min.js"></script>
329 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
330 <script src="assets/js/affix.js"></script>
331 <script src="assets/js/alert.js"></script>
332 <script src="assets/js/alert1.js"></script>
333 <script src="assets/js/bootstrap.js"></script>
334 <script src="assets/js/bootstrap.min.js"></script>
335 <script src="assets/js/bootstrap-datepicker.js"></script>
336 <script src="assets/js/bootstrap-wysihtml5.js"></script>
337 <script src="assets/js/button.js"></script>
338 <script src="assets/js/carousel.js"></script>
339 <script src="assets/js/chosen.jquery.min.js"></script>
340 <script src="assets/js/ckeditor.js"></script>
341 <script src="assets/js/collapse.js"></script>
342 <script src="assets/js/color.js"></script>
343 <script src="assets/js/dropdown.js"></script>
344 <script src="assets/js/DT_bootstrap.js"></script>
345 <script src="assets/js/dynamic.js"></script>
346 <script src="assets/js/ie-emulation-modes-warning.js"></script>
347 <script src="assets/js/jquery.dataTables.js"></script>
348 <script src="assets/js/jquery.dataTables.min.js"></script>
349 <script src="assets/js/jquery.dialog.js"></script>
350 <script src="assets/js/jquery.hoverdir.js"></script>
351 <script src="assets/js/jquery.jgrowl.js"></script>
352 <script src="assets/js/jquery.knob.js"></script>
353 <script src="assets/js/jquery.uniform.min.js"></script>
354 <script src="assets/js/jquery-1.8.3.min.js"></script>
355 <script src="assets/js/jquery-1.9.1.js"></script>
356 <script src="assets/js/jquery-1.9.1.min.js"></script>
357 <script src="assets/js/jquery-1.10.2.js"></script>
358 <script src="assets/js/jquery-1.11.0.js"></script>
359 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
360 <script src="assets/js/jquery-ui-1.10.3.js"></script>
361 <script src="assets/js/modal.js"></script>
362 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
363 <script src="assets/js/myjquery.js"></script>
364 <script src="assets/js/myjquery1.js"></script>
365 <script src="assets/js/npm.js"></script>
366 <script src="assets/js/popover.js"></script>
367 <script src="assets/js/profile.js"></script>
368 <script src="assets/js/raphael-min.js"></script>
369 <script src="assets/js/sb-admin-2.js"></script>
370 <script src="assets/js/scripts.js"></script>
371 <script src="assets/js/scrollspy.js"></script>
372 <script src="assets/js/tab.js"></script>
373 <script src="assets/js/tooltip.js"></script>
374 <script src="assets/js/transition.js"></script>
375 <script src="assets/js/wysihtml5-0.3.0.js"></script>
376 <!--when everything is fine the loades stops loadeing-->
377 <script language="javascript" type="text/javascript">
378 $(window).load(function()
379 {
380 $('#loading').hide();
381 });
382 </script>
383
384 </body>
385
386 </html>